SELECT co.idcounty,city.City,city.simplified AS cityname,s.state,s.fullstate,h.Zip,h.UpDateTime,h.True_statusid,h.PropertyTypeid,h.ListPrice ,h.Beds,h.Baths,h.Sqft,h.LotSize,h.YearBuilt,h.Address ,h.ImageCity,h.image_main,h.listdate,h.HomeID,h.StatusID,h.table1_name,h.table1_id
FROM home AS h LEFT JOIN status AS city ON h.StatusID = city.StatusID LEFT JOIN county AS co ON city.idcounty = co.idcounty LEFT JOIN state AS s ON co.idstate = s.idstate
WHERE h.recommend = 1 AND h.StatusID in (360) ORDER BY h.UpDateTime desc limit 6